package com.program.facesigninsystem.dao;

import com.alibaba.fastjson.JSONObject;
import com.program.facesigninsystem.entity.CourseOrganization;
import com.program.facesigninsystem.entity.Organization;
import com.program.facesigninsystem.entity.SuperiorsOrganization;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface ISuperiorsOrganizationDao {
    void addNewSO(
            @Param("oid") String oid,
            @Param("sid") String sid,
            @Param("application_status") Integer application_status,
            @Param("createtime") String createtime

    );

    //申请被驳回
    void updateapplystates3(
            @Param("soid") String soid
    );

    void updateapplystates2(
            @Param("soid") String soid
    );

    void updateapplystates4(
            @Param("soid") String soid
    );

    SuperiorsOrganization selectapplyhistory(
            @Param("oid") String oid,
            @Param("sid") String sid
    );

    List<SuperiorsOrganization> selectapplyhistory1(
            @Param("oid") String oid
    );

    List<SuperiorsOrganization> selectbind(
            @Param("oid") String oid
    );


    List<SuperiorsOrganization> selectsup(
            @Param("oid") String oid
    );
    List<SuperiorsOrganization> selectbdhistory(
            @Param("oid") String oid
    );
    List<SuperiorsOrganization> selectbindbyoname(
            @Param("oid") String oid,
            @Param("oname") String oname
    );

    String selectwhethersee(@Param("oid") String oid,@Param("sid") String sid);

    void updatewhethersee(@Param("oid") String oid,@Param("sid") String sid,@Param("whethersee") String whethersee);

    List<String> selectjunior(@Param("oid") String oid);
    void deletebyoid(@Param("oid") String oid);

    void deletebysid(@Param("sid") String sid);
}
